package cg.project.pojo;

import lombok.AllArgsConstructor;
import lombok.Data;
import lombok.NoArgsConstructor;

import java.io.Serializable;

@Data
@AllArgsConstructor
@NoArgsConstructor
public class Car implements Serializable {
    private Integer id;            // 汽车ID
    private String brand;       // 汽车品牌
    private String model;      // 汽车型号
    private double price;     // 汽车价格
    private String imagePath;  // 图片路径
    private String description;  // 汽车描述
}
/*
CREATE TABLE t_car (
                       id INT AUTO_INCREMENT PRIMARY KEY,
                       brand VARCHAR(50),
                       model VARCHAR(50),
                       price DECIMAL(10, 2),
                       image_path VARCHAR(200),
                       description VARCHAR(500)
);
ALTER TABLE t_car MODIFY brand VARCHAR(50) CHARACTER SET utf8mb4;
ALTER TABLE t_car CONVERT TO CHARACTER SET utf8mb4;
-- 插入第1条汽车数据
INSERT INTO t_car (brand, model, price, image_path, description) VALUES ('丰田', '卡罗拉', 128901.23, '10001.jpeg', '经济实惠的家用轿车，燃油经济性出色。');
-- 插入第2条汽车数据
INSERT INTO t_car (brand, model, price, image_path, description) VALUES ('本田', '思域', 156789.01, '10002.jpeg', '时尚动感的车型，动力性能良好。');
-- 插入第3条汽车数据
INSERT INTO t_car (brand, model, price, image_path, description) VALUES ('大众', '朗逸', 145678.90, '10003.jpeg', '畅销的家用车，空间宽敞舒适。');
-- 插入第4条汽车数据
INSERT INTO t_car (brand, model, price, image_path, description) VALUES ('福特', '福克斯', 167890.12, '10004.jpeg', '操控性佳的运动风格轿车。');
-- 插入第5条汽车数据
INSERT INTO t_car (brand, model, price, image_path, description) VALUES ('别克', '英朗', 134567.89, '10005.jpeg', '车内配置丰富，驾乘体验不错。');
-- 插入第6条汽车数据
INSERT INTO t_car (brand, model, price, image_path, description) VALUES ('雪佛兰', '科鲁兹', 148901.23, '10006.jpeg', '外观设计时尚，性价比高。');
-- 插入第7条汽车数据
INSERT INTO t_car (brand, model, price, image_path, description) VALUES ('日产', '轩逸', 156789.01, '10007.jpeg', '以舒适性和燃油经济性著称的。');
-- 插入第8条汽车数据
INSERT INTO t_car (brand, model, price, image_path, description) VALUES ('马自达', '昂克赛拉', 167890.12, '10008.jpeg', '操控灵敏，外观动感，深受年轻人喜爱。');
-- 插入第9条汽车数据
INSERT INTO t_car (brand, model, price, image_path, description) VALUES ('现代', '领动', 145678.90, '10009.jpeg', '空间宽敞，适合家庭出行的实用车型。');
-- 插入第10条汽车数据
INSERT INTO t_car (brand, model, price, image_path, description) VALUES ('起亚', 'K3', 138901.23, '10010.jpeg', '经济实惠的家用车选择。');
-- 插入第11条汽车数据
INSERT INTO t_car (brand, model, price, image_path, description) VALUES ('奔驰', 'C级', 367890.12, '10011.jpeg', '豪华品牌轿车，内饰精致。');

-- 插入第13条汽车数据
INSERT INTO t_car (brand, model, price, image_path, description) VALUES ('宝马', '3系', 390123.45, '10012.jpeg', '经典的豪华运动轿车，驾驶乐趣十足。');
-- 插入第14条汽车数据
INSERT INTO t_car (brand, model, price, image_path, description) VALUES ('奥迪', 'A4L', 378901.23, '10013.jpeg', '科技感与舒适性兼备的豪华车。');
-- 插入第15条汽车数据
INSERT INTO t_car (brand, model, price, image_path, description) VALUES ('雷克萨斯', 'ES', 389012.34, '10014.jpeg', '豪华舒适的进口轿车，品质卓越。');
-- 插入第15条汽车数据（接上一行代码修正后完整内容）
INSERT INTO t_car (brand, model, price, image_path, description) VALUES ('雷克萨斯', 'ES', 389012.34, '10014.jpeg', '豪华舒适的进口轿车，品质卓越。');
-- 插入第16条汽车数据
INSERT INTO t_car (brand, model, price, image_path, description) VALUES ('凯迪拉克', 'CT5', 345678.90, '10016.jpeg', '具有美式豪华风格的轿车，动力强劲。');
-- 插入第17条汽车数据
INSERT INTO t_car (brand, model, price, image_path, description) VALUES ('沃尔沃', 'XC60', 367890.12, '10017.jpeg', '安全性能卓越的豪华SUV。');
-- 插入第18条汽车数据
INSERT INTO t_car (brand, model, price, image_path, description) VALUES ('捷豹', 'XEL', 390123.45, '10018.jpeg', '优雅的豪华轿车，操控性能出色。');
-- 插入第19条汽车数据
INSERT INTO t_car (brand, model, price, image_path, description) VALUES ('路虎', '发现运动版', 378901.23, '10019.jpeg', '豪华SUV，越野能力与舒适性兼顾。');

INSERT INTO t_car (brand, model, price, image_path, description) VALUES ('玛莎拉蒂', '总裁', 490123.45, '10020.jpeg', '奢华的意大利跑车，动力澎湃。');
-- 插入第21条汽车数据
INSERT INTO t_car (brand, model, price, image_path, description) VALUES ('丰田', 'RAV4荣放', 198901.23, '10021.jpeg', '实用的SUV车型，空间较大。');
-- 插入第22条汽车数据
INSERT INTO t_car (brand, model, price, image_path, description) VALUES ('本田', 'CR-V', 208901.23, '10022.jpeg', '受欢迎的SUV，舒适性不错。');
-- 插入第23条汽车数据
INSERT INTO t_car (brand, model, price, image_path, description) VALUES ('大众', '途观L', 256789.01, '10023.jpeg', '中型SUV，销量较好。');
-- 插入第24条汽车数据
INSERT INTO t_car (brand, model, price, image_path, description) VALUES ('福特', '锐界', 278901.23, '10024.jpeg', '中大型SUV，动力较强。');
-- 插入第25条汽车数据
INSERT INTO t_car (brand, model, price, image_path, description) VALUES ('别克', '昂科威', 234567.89, '10025.jpeg', '豪华感较强的SUV，配置丰富。');
-- 插入第26条汽车数据
INSERT INTO t_car (brand, model, price, image_path, description) VALUES ('雪佛兰', '探界者', 218901.23, '10026.jpeg', '性价比高的SUV，外观硬朗。');
-- 插入第27条汽车数据
INSERT INTO t_car (brand, model, price, image_path, description) VALUES ('日产', '奇骏', 205678.90, '10027.jpeg', '舒适性SUV，适合家用。');
-- 插入第28条汽车数据
INSERT INTO t_car (brand, model, price, image_path, description) VALUES ('马自达', 'CX-5', 234567.89, '10028.jpeg', '操控性好的SUV，外观时尚。');
-- 插入第29条汽车数据
INSERT INTO t_car (brand, model, price, image_path, description) VALUES ('现代', 'ix35', 189012.34, '10029.jpeg', '经济实惠的SUV，空间够用。');
-- 插入第30条汽车数据
INSERT INTO t_car (brand, model, price, image_path, description) VALUES ('起亚', '智跑', 178901.23, '10030.jpeg', '家用SUV，性价比不错。');
-- 插入第31条汽车数据
INSERT INTO t_car (brand, model, price, image_path, description) VALUES ('奔驰', 'GLC', 434567.89, '10031.jpeg', '豪华中型SUV，内饰精美。');
 */